UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nFzgJVHNNTum0YxJAt8F6Kgd5toH0IedrpBF5xpqLHk='
WHERE
key_id = 'd070aef12ae9b8f349a7a7d447cacc276521c67ec5a556adcd5ad1faf9adc1d0'
AND (
token = 'nFzgJVHNNTum0YxJAt8F6Kgd5toH0IedrpBF5xpqLHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)