UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjwB0TRt4WPHvTH1t88N3rqRRk/kNfMAAp7VwLZ//N4='
WHERE
key_id = '31bc014cfada060db6c05049438fdb0a1555e3c9a4e00c087c87a7743bf02307'
AND (
token = 'mjwB0TRt4WPHvTH1t88N3rqRRk/kNfMAAp7VwLZ//N4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)