UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sZBwnqh5IHDWPgUJiRe5fgwA9JjYpUwWIh3lYNDiTMM='
WHERE
key_id = '417c6cf9c43dab413ddd52ba7f347d9e191c55db120f0ddee8d070ee44400161'
AND (
token = 'sZBwnqh5IHDWPgUJiRe5fgwA9JjYpUwWIh3lYNDiTMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)