UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ac8XOuhIZgOsP0ayrL8QTBeQD9kHj5kBvi35IO0UW54='
WHERE
key_id = 'bf615aadd248afab5682ce93b2fe35bd489666ac576644bbc02531347c271554'
AND (
token = 'Ac8XOuhIZgOsP0ayrL8QTBeQD9kHj5kBvi35IO0UW54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)