UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRGQpqX/zLGah6p3Ge48s/tqED8N6pxE4vUu8cvplWY='
WHERE
key_id = 'fe5f7212cd6f2432f2bad4bae4c154ac5ec14cf73aa9592626b5482dd9bf5a40'
AND (
token = 'zRGQpqX/zLGah6p3Ge48s/tqED8N6pxE4vUu8cvplWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)