UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUOjkmeXMWWO3pYwc/8f/1YrzqICEyqtPQdLBKy5teU='
WHERE
key_id = 'db5a3fb60d498bb5e4cc8c29d5f39b2a16d43dc33de61f7bb49794afa57f0436'
AND (
token = 'zUOjkmeXMWWO3pYwc/8f/1YrzqICEyqtPQdLBKy5teU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)