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