UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R+tcr8LkcmDSr8u1whOhzAszBxX+H4kGGMuF0UXwetI='
WHERE
key_id = '149dbc2e1bfb1cbac99e769099dd6a63db7f3876be4b9320324765f8473fbb70'
AND (
token = 'R+tcr8LkcmDSr8u1whOhzAszBxX+H4kGGMuF0UXwetI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)