UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ciT/UEHergfzDcI1kE/t+cW9ZOaJ6Bc8xRuVfF7HDY='
WHERE
key_id = '6edba71be1f6ed249338fa566013fc80312c24699f323abc03449b958879144c'
AND (
token = '8ciT/UEHergfzDcI1kE/t+cW9ZOaJ6Bc8xRuVfF7HDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)