UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fL9ZHVyd8KP9Ki34gxUQ7wkSe/rr0bIGHDvIdCUvbtY='
WHERE
key_id = 'eb08b35b5e2c9abdd487837b1e5caaf4b83e09bff427ac7a8f5a8e0d27f80357'
AND (
token = 'fL9ZHVyd8KP9Ki34gxUQ7wkSe/rr0bIGHDvIdCUvbtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)