UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v3Vqz3G2yyHtHk0OHqfN/JNZGC0mduFzp3slr9XgUd4='
WHERE
key_id = 'aa47620f0685086d06112d671e06952df6de5090073a8ec9deb4110294db771a'
AND (
token = 'v3Vqz3G2yyHtHk0OHqfN/JNZGC0mduFzp3slr9XgUd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)