UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GK3d22zJnF6SBeL/OKKeE5ZbFCAlnp6JdCDjjS3nC4='
WHERE
key_id = 'b852f0126a12107ba9f94c74a001e30d5da7df8d7d8ba52f72370b14692fca82'
AND (
token = '7GK3d22zJnF6SBeL/OKKeE5ZbFCAlnp6JdCDjjS3nC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)