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