UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TaPfM0w4QCNfXWZ5cZ3I9cWddgrYlR6HYwUMVNMsYWA='
WHERE
key_id = '500d15cb9b25c0c1ee2a03a4d5e27490b2433dea31bb81881795c4a90a28eeaf'
AND (
token = 'TaPfM0w4QCNfXWZ5cZ3I9cWddgrYlR6HYwUMVNMsYWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)