UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hntB3jnjSwNXdPZZ/VXQ9VghhFNTr82sEby71Uv13uc='
WHERE
key_id = '749f8c1604466ce605f82667d79960d9821562c1effe015a95f62288ba90f6e1'
AND (
token = 'hntB3jnjSwNXdPZZ/VXQ9VghhFNTr82sEby71Uv13uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)