UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ySCgISCbfAZzyLz4NbH0J7r0VdO9gJXcdsl2llziaec='
WHERE
key_id = 'e13a7173f1260d4af48d75d58fdec0a2e1a5b7792c344e2886622c55c27cfe21'
AND (
token = 'ySCgISCbfAZzyLz4NbH0J7r0VdO9gJXcdsl2llziaec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)