UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tIe4IHMmmBhrfv3wK5latfgDWk8Hs6afJTzplu4+2Uk='
WHERE
key_id = '3578b2edcfd90530a2b31f17f7e5f7cff61987f5205aaebe2d73c3b70a678a72'
AND (
token = 'tIe4IHMmmBhrfv3wK5latfgDWk8Hs6afJTzplu4+2Uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)