UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXm0p83+L0dU6mC1uI15X1m6zoGRiSBysN2bVpN2u5U='
WHERE
key_id = '92e2ba0afd5a1ec305a91f13696b11a8a8fa22166bf94688a88cc5c8cbb42a53'
AND (
token = 'WXm0p83+L0dU6mC1uI15X1m6zoGRiSBysN2bVpN2u5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)