UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aXcZQArZ7q7DHde6MUwEmeYVNOg1zwdEHl0BHd3nYEQ='
WHERE
key_id = '16e1b2ef7c3e9a626a2462a8b473bf12cc20919c90c8846a587b12d3b7544ae9'
AND (
token = 'aXcZQArZ7q7DHde6MUwEmeYVNOg1zwdEHl0BHd3nYEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)