UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vy1raQqH3YuQJdQ83BNh/hjNZE9MIEbin80BKI7VSRU='
WHERE
key_id = '03c6278f05e9e807b2aa5e47d963844a26a29d3439666baa6581e0536d63c6a5'
AND (
token = 'vy1raQqH3YuQJdQ83BNh/hjNZE9MIEbin80BKI7VSRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)