UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nubMp4yYhrPzHY5kVhsl1BL2Qww2gQ0ASx3qwBxGYLA='
WHERE
key_id = '1a47d2f69d72d84bcb35a51589e8849e5f70e046990cdd76adad7cda244c3d37'
AND (
token = 'nubMp4yYhrPzHY5kVhsl1BL2Qww2gQ0ASx3qwBxGYLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)