UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ct7gPDJ4LArp6uW/pC8YuNPlvlXj0yXix1WH77Om94o='
WHERE
key_id = 'c02e4793b51df2930b6913e2a65c571800503b051416b9ebd0aa30798646acac'
AND (
token = 'Ct7gPDJ4LArp6uW/pC8YuNPlvlXj0yXix1WH77Om94o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)