UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fGQBoPThLTV2kn8e4n8QwAdIGDW5LQfl1JdXChzjYfE='
WHERE
key_id = '5caa84a529e0792f7c12b42b766ca3cbb1adc1e93fffa68dcc942c5dc66f5775'
AND (
token = 'fGQBoPThLTV2kn8e4n8QwAdIGDW5LQfl1JdXChzjYfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)