UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVBEdyt5YCu5E0ilrNgWEFjOGGUarMLyr/hUyxYU4Tw='
WHERE
key_id = 'e0e43029c33172695e8c43fa7fc7d0f7bbb2b9d53d45a9d4288dbcd38f45c572'
AND (
token = 'zVBEdyt5YCu5E0ilrNgWEFjOGGUarMLyr/hUyxYU4Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)