UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBacFg8oLqe21V41DVHTwZJZ+M6p4lQWJCpe789HLdM='
WHERE
key_id = 'fd58e857465c08b1b200e857fa66413c8c8321333c5d3dc56928602f76b815b5'
AND (
token = 'mBacFg8oLqe21V41DVHTwZJZ+M6p4lQWJCpe789HLdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)