UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '28xmF4c96T35wRiwtuMOjqffxy/7+jHcnGo/6L4wZHE='
WHERE
key_id = 'e65079d56b8015261b1104a46f57157e6dd8b632ca9620f58f9193a1e77e08b0'
AND (
token = '28xmF4c96T35wRiwtuMOjqffxy/7+jHcnGo/6L4wZHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)