UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Pxk8Mb3ltdOwn9trJhBmdhp0+p8bvn6/33R2aROON8='
WHERE
key_id = 'f420a02e136c4711021d372902cd3eb783760a681ca0c73c5f4a08f9d5928bd4'
AND (
token = '9Pxk8Mb3ltdOwn9trJhBmdhp0+p8bvn6/33R2aROON8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)