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