UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wdy/eHl04JJngkXthTd/MhOCOvkA6+ZYvVO+vkZjBtw='
WHERE
key_id = 'ef79551ffa24925b7eb861a684e886add0356747ba27848ce286e38cf346aff5'
AND (
token = 'wdy/eHl04JJngkXthTd/MhOCOvkA6+ZYvVO+vkZjBtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)