UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PbmQGF9F1fKDM8y9bLhf4Un/FnfMuIw6dKH0VgW5xb8='
WHERE
key_id = 'dab348e36b840352962f822cf98ab0a5cb06bf6f31ce8626f78057b737fc108d'
AND (
token = 'PbmQGF9F1fKDM8y9bLhf4Un/FnfMuIw6dKH0VgW5xb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)