UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nh8gomcCfwH3X/twJYod7chI5X1I+2I+nZCvDvp6kO0='
WHERE
key_id = '9a27bcf961ec13a61042703bcadf584308e6da9216b8cfce67a6986414634539'
AND (
token = 'Nh8gomcCfwH3X/twJYod7chI5X1I+2I+nZCvDvp6kO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)