UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qESd0fq4gU3AcL94BcFkG4gFsUPu+jgWHT5Phn7IhLg='
WHERE
key_id = '547f65f9a674d44a1b5e9a7ed963ec77b211883dbf7a86a52907bedfda92ca5c'
AND (
token = 'qESd0fq4gU3AcL94BcFkG4gFsUPu+jgWHT5Phn7IhLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)