UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DMGe6XqmyB9bVnMOEfKjaKfY8FKenw8ugsi2vBTLaWQ='
WHERE
key_id = '4ae7143d9db4b08113d13f2d0f5e63a8f3a35082fb6fb3b148005dada13b6482'
AND (
token = 'DMGe6XqmyB9bVnMOEfKjaKfY8FKenw8ugsi2vBTLaWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)