UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xWpCfqapSIC1cTreKrBZkjHcDX0kTVejDSn2jOiR7TQ='
WHERE
key_id = '81d1ba376da7a58dcdf5d16e4b4340984c19b1c75f54cdebcc58af26727105d6'
AND (
token = 'xWpCfqapSIC1cTreKrBZkjHcDX0kTVejDSn2jOiR7TQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)