UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXfJXme5yMIA9mUfWySGe19r4iYvUb9lTEgJWH73MS8='
WHERE
key_id = '9bc79ca51ee140cdea3215a78cd01145f8ca4c09d5d6319782ed39af109ab484'
AND (
token = 'QXfJXme5yMIA9mUfWySGe19r4iYvUb9lTEgJWH73MS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)