UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/czXzWIE82HARujBsOM0echqPwnR0fkJTdMGa1n9tqc='
WHERE
key_id = '2fc8e12b9bd922fd7fa85111a49b7691033240b557fba23c200616f856b8ce99'
AND (
token = '/czXzWIE82HARujBsOM0echqPwnR0fkJTdMGa1n9tqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)