UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRX/9QGwEqaAF6gKWDav60P1ozlwS50i1GQ3hbLcNRk='
WHERE
key_id = 'bb50b26f469daaa4b66fdf5d3878c9713ffc7b64d3cdfa7d32488f029218ff79'
AND (
token = 'lRX/9QGwEqaAF6gKWDav60P1ozlwS50i1GQ3hbLcNRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)