UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWU1Rms6FD70ZZX5puXU3Eu/IvZc22BEW4/nqS19/7A='
WHERE
key_id = 'd48385273fd9450f225c109272fe495aa6683109e8135078248fc8c1efbcd50f'
AND (
token = 'bWU1Rms6FD70ZZX5puXU3Eu/IvZc22BEW4/nqS19/7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)